// 票据操作记录
const {DataTypes, db } = require("../db");
db.define('invoiceLog', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
op:{type: DataTypes.STRING(255),allowNull:false,comment:'动作 新增，修改，审核，退审，删除'}, 
iid:{type: DataTypes.INTEGER,allowNull:false,comment:'票据ID'}, 
uid:{type: DataTypes.INTEGER,comment:'操作人'}, 
data:{type: DataTypes.TEXT,comment:'票据内容'}, 
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
ctime:{type: DataTypes.STRING,defaultValue:''},
ip:{type: DataTypes.STRING(100),comment:'客户机ip'}, 
byCell:{type: DataTypes.INTEGER,defaultValue:0,comment:'0电脑1手机2客户自助'}, 

}, {
    tableName: 'invoice_log',
    timestamps: false,
    comment: '票据操作记录'
});